Order By For Print Template Stored Procedures

Document Version	v.2
Document Last Updated	2/3/2020
Software Version Documented	v.9.5.83

Order By for Print Template Stored Procedures

The document describes how each print template orders the data for viewing.

Quote

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending number.

Order

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending number.

RFQ

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending number.

PO

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending number.

PT

If options ShowPertinent and ShowAll are not selected then
- Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Picked From Location Ascending then by Manufacturer Short Name Ascending then finally by Part Number Ascending.
If ShowPertinent or ShowAll are selected and PrintOrder is selected then
- Ordered by Is Item On Back Order Ascending then by Picked From Location Ascending then by Inventory Location Ascending then by Line Item Sequence Ascending.
If ShowPertinent or ShowAll are selected and PrintOrder is not selected then
- Ordered by Is Item On Back Order Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Picked From Location Ascending then by Inventory Location Ascending.

Shipper Items

If options ShowPertinent and ShowAll are not selected then
- Ordered by Order Shipper Number Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending.
If ShowPertinent or ShowAll are selected then
- Ordered by Is Item On Back Order Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Picked From Location Ascending then by Inventory Location Ascending.

PutAway

Ordered by Is Item Held For Back Order Ascending then by Location Ascending number then by Manufacturer Short Name Ascending then by Part Number Ascending.

Invoice

Ordered by Order Shipper Number Ascending then by CustomOrderColumn Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending.
If ShowPertinent or ShowAll are selected then
- Ordered by Is Item On Back Order Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

Receiver

Ordered by Is Item Held For Back Order Ascending then by Location Ascending then by Manufacturer Short Name Ascending then by Part Number Ascending.

InventoryLabel

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

ShipperLabel Items

Ordered by Order Shipper Number Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Order Line Item Sys Ascending.

Shipper Packages

First ordered by Order Shipper Package Sys Ascending then by Is Item On Back Order Ascending.
- If ShowPertinent or ShowAll are selected then
  - Ordered by Order Shipper Package Sys Ascending.

ShippingLabel Packages

Ordered by Order Shipper Package Sys Ascending.

InstallLocationLabel

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

Manifest

Ordered by Stop Delivery Sequence Ascending then by Stop Sys Ascending.

Shipper BillingCopy

If options ShowPertinent and ShowAll are not selected then
- Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Order Line Item Ascending.
If ShowPertinent or ShowAll are selected then
- Ordered by Is Item On Back Order Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Picked From Location Ascending then by Inventory Location Ascending.

Shipper DriverCopy

If options ShowPertinent and ShowAll are not selected then
- Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Order Line Item Ascending.
If ShowPertinent or ShowAll are selected then
- Ordered by Is Item On Back Order Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Picked From Location Ascending then by Inventory Location Ascending.

PayableInvoice

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

Shipper Signature

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

Receipt

Ordered by Order Shipper Number Ascending then by Custom Order Column Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending.
If ShowPertinent or ShowAll are selected then
- Ordered by Is Item On Back Order Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

Statement

Ordered by Transaction Date Ascending then by Order Number Ascending then by Order Shipper Number Ascending.

Record Deposit Slip

Ordered by Payment History Header Sys.

CheckSlipInfo

Ordered by Remit Vendor Long Name then by Vendor Sys then by Check Header Sys then by Primary Vendor Long Name.

Get Remittance Advice

Ordered by Bill Header Sys.

RebateClaim

Ordered by Order Number then by Order Shipper Number.

CreditMemo

Ordered by Credit Memo Number then by Order Number then by RMA Receiver Number.

RMAReceipt

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

RTVPT

Ordered by RTV Shipper Number Ascending Line Item Sequence Ascending then by Order Line Item Sys Ascending.
If @ShowPertinent or @ShowAll are selected then
- Ordered by Is Item On Back Order Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Picked From Location Ascending then by Inventory Location Ascending.

Shipper DriverCopy

If options ShowPertinent and ShowAll are not selected then
- Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Order Line Item Ascending.
If ShowPertinent or ShowAll are selected then
- Ordered by Is Item On Back Order Ascending then by Line Item Sequence Ascending then by Order Line Item Sys Ascending then by Picked From Location Ascending then by Inventory Location Ascending.

CustomerReturn

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

RMA

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

PaymentReceipt

Ordered by Date Created then by Money Transaction Type Sys.

RefundReceipt

Ordered by Date Created then by Money Transaction Type Sys.

VendorReturn

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

RTV

Ordered by Line Item Sequence Ascending then by Order Line Item Sys Ascending.

ShippingLabel PackagesSimple

Ordered by Min Package Count Ascending.